Computers / Programming / Projects / Budgetor / Data Viewer - Database Classes

Overview

These is the LINQ to SQL data context class and related helper classes used in the prototype DataViewer program.

BudgeterDataContext.cs

cs type icon
Type: Data Context
Language: XAML
BudgeterDataContext.cs

This is the LINQ to SQL data context class used to interact with the database. It controls the database connection as well as table references. In the DataViewer it is also used to store related information used by the program. There are constant strings which are used by the program to list the available tables and allow the program to determine which table has been selected. The class also contains GridView objects for each table which the program uses to format data for that table. The class is also used to test the database connection to make sure it's using the correct schema.

ConnectionStringManager.cs

cs type icon
Type: Helper Class
Language: C#
ConnectionStringManager.cs

This is a helper class to make configuration of the database connection easier. It handles building the connection string as well as saving and loading the connection values to the config file.

Enums.cs

cs type icon
Type: Helper class
Language: C#
Enums.cs

This class defines several enums which several database columns are linked to. The DataViewer program only displays this information but the future budgeter program will use them to determine how to treat various objects.